Managed Instance - Weekly report of logins
What's the best way to get a weekly report from an Azure Managed Instance giving all logon information (User, date, IP, success, etc)? I want all SQL logins and Entra ID logins. I've followed the steps detailed here:…
Debugging SQL Server on Linux from remote VS 2022 pc
Is it possible to debug an SQL-Server on an Ubuntu 22 machine from Visual Studio 2022? I can reach the server an can execute queries from within VS2022. But debugging fails with no useful message (error 80004005). Firewall on the server pc is inactive.…
Cannot add drive using Failover Cluster Manager - no disks suitable for cluster disks were found
I am creating a new SQL cluster to replace out old cluster. I created a new, two server cluster running Server 2022. I am told I need to add the disk to the cluster before I can install our SQL server software. I created a new volume in our PowerStore.…
My listview is listing only the id instead of 3 items on the table
PLEASE HELP ME I am working on sqlite database , i have the following code in c# maui return (await conn.Table<ServiceData>().ToListAsync()) ```.Where(s…
Path to Microsoft ODBC SSL Driver loaded libraries
How do configure dynamic loading of OpenSSL libraries for use MS ODBC? The Microsoft ODBC Driver for SQL Server on Linux version 17 dynamically loads the latest version of libssl based on its availability on the system. Our software is linked custom…
The MSSQLSERVER and AGENT service terminated unexpectedly
Dear All SQL expert, Do you know what is the case that make The MSSQLSERVER service terminated unexpectedly? Recently, The SQL server (MSSQLSERVER) and SQL Server Agent are stopped automatically during running import data to sql server through scheduled…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
Reporting Services logs and database tables
hi all, Do the RS logs and various log database tables contain the same information? I have no access to the admin page for the production environment RS, however I am responsible for fixing issues with reports being scheduled in that…
How to connect my c# application to my phpmyadmin database from my NAS?
Good day, I want to try to connect to my database in my NAS. Please take a look the image below. As you can see at the image, I want to access my database outside in my home network. I already installed phpmyadmin in my NAS, but the problem is I don't…
SSRS Report Subscription Windows Share File Option Failed
We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…
How to install SQL Server 2022 on Ubuntu Server 24.04 LTS
I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…
Dataset format needed for azure blob storage
How do I select what format is right for me while moving documents from SQL Server to Azure blob storage using Azure Data Factory pipeline? The existing documents in the Blob storage show the type as Block Blob, but it doesn't show the format. I need to…
Polybase s3 not working on SQL Server 2022 Linux
Trying to connect to parquet files on S3 from SQL server 2022 Linux fails with the following error: CREATE EXTERNAL DATA SOURCE myds WITH ( LOCATION = 's3://mybucket' , CREDENTIAL = mycreds ); GO 111631;The specified…
Windows 11 Microsoft SQL 2022 Express Edition
Hey, currently in work we have PC with Windows 11 Pro license which is used as small "server". Here we have installed MS SQL servers. We want to add new software database into MS SQL 2022 Express Edition but software creator said we need…
bit null ,0
Hey Team, have column1 datatype (bit,null) so it only takes values like 0 and 1 but i want true , false as well...how to get that in same datatype or in different one
Transfer roles and permissions
Hi, By using sp_help_revlogin, we can transfer the logins and passwords to the secondary replica. How to transfer roles and permissions?
Transfer documents from sqlserver in varbinary to Azure Blob storage
I am looking to move a large set of documents from a Managed Instance of SQL Server database where the documents are saved in varbinary data type on the sql server table. The ADF dataflow I created doesn't let me select a Azure Blob 'Binary' as the sink…
How do I copy all columns properties with copy activity in data factory
Hi, I'm copying data from one DB to another DB with copy activity and auto create table. I noticed that when the table is creating on the target side it is creating with the column size and type but all the other properties are lost, for example…
Hyper-V replica - EnableWriteOrderPreservationAcrossDisk for SQL VM not working
According to Support policy for hardware virtualization product - SQL Server | Microsoft Learn, Hyper-V replica for a VM running SQL server is a supported scenario as long as you enable EnableWriteOrderPreservationAcrossDisks as described in the…
Availability Groups in depth
Hi, I want in depth information on Availability Groups. Any link that I can read?